Dataset statistics
| Number of variables | 11 |
|---|---|
| Number of observations | 1048575 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 290.8 MiB |
| Average record size in memory | 290.8 B |
Variable types
| Numeric | 8 |
|---|---|
| Categorical | 3 |
CREATED_AT has a high cardinality: 1038198 distinct values | High cardinality |
UPDATED_AT has a high cardinality: 1046245 distinct values | High cardinality |
AMOUNT is highly overall correlated with FEES and 3 other fields | High correlation |
FEES is highly overall correlated with AMOUNT and 3 other fields | High correlation |
RETAILER_CUT is highly overall correlated with AMOUNT and 3 other fields | High correlation |
TOTAL_AMOUNT_INCLUDING_TAX is highly overall correlated with AMOUNT and 3 other fields | High correlation |
TOTAL_AMOUNT_PAID is highly overall correlated with AMOUNT and 3 other fields | High correlation |
STATUS is highly imbalanced (95.6%) | Imbalance |
AMOUNT is highly skewed (γ1 = 32.92559311) | Skewed |
FEES is highly skewed (γ1 = 82.21787189) | Skewed |
RETAILER_CUT is highly skewed (γ1 = 41.577119) | Skewed |
TOTAL_AMOUNT_INCLUDING_TAX is highly skewed (γ1 = 32.78087174) | Skewed |
TOTAL_AMOUNT_PAID is highly skewed (γ1 = 32.68072135) | Skewed |
CREATED_AT is uniformly distributed | Uniform |
UPDATED_AT is uniformly distributed | Uniform |
ID has unique values | Unique |
Reproduction
| Analysis started | 2023-04-04 16:05:04.697113 |
|---|---|
| Analysis finished | 2023-04-04 16:05:46.111171 |
| Duration | 41.41 seconds |
| Software version | ydata-profiling vv4.1.2 |
| Download configuration | config.json |
ID
Real number (ℝ)
| Distinct | 1048575 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21187328 |
| Minimum | 44446 |
|---|---|
| Maximum | 57640096 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 MiB |
Quantile statistics
| Minimum | 44446 |
|---|---|
| 5-th percentile | 8251421.7 |
| Q1 | 13539386 |
| median | 20673482 |
| Q3 | 25437632 |
| 95-th percentile | 41556269 |
| Maximum | 57640096 |
| Range | 57595650 |
| Interquartile range (IQR) | 11898245 |
Descriptive statistics
| Standard deviation | 10240261 |
|---|---|
| Coefficient of variation (CV) | 0.48332007 |
| Kurtosis | 0.071443264 |
| Mean | 21187328 |
| Median Absolute Deviation (MAD) | 6610793 |
| Skewness | 0.76170538 |
| Sum | 2.2216502 × 1013 |
| Variance | 1.0486294 × 1014 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 21321668 | 1 | < 0.1% |
| 41615753 | 1 | < 0.1% |
| 41654058 | 1 | < 0.1% |
| 41654060 | 1 | < 0.1% |
| 51358960 | 1 | < 0.1% |
| 36193663 | 1 | < 0.1% |
| 36193692 | 1 | < 0.1% |
| 36193693 | 1 | < 0.1% |
| 36193704 | 1 | < 0.1% |
| 36193708 | 1 | < 0.1% |
| Other values (1048565) | 1048565 |
| Value | Count | Frequency (%) |
| 44446 | 1 | |
| 45307 | 1 | |
| 45811 | 1 | |
| 165403 | 1 | |
| 295226 | 1 | |
| 295484 | 1 | |
| 295717 | 1 | |
| 295853 | 1 | |
| 296154 | 1 | |
| 296410 | 1 |
| Value | Count | Frequency (%) |
| 57640096 | 1 | |
| 57640085 | 1 | |
| 57640080 | 1 | |
| 57640079 | 1 | |
| 57640036 | 1 | |
| 57640033 | 1 | |
| 57640024 | 1 | |
| 57639950 | 1 | |
| 51367348 | 1 | |
| 51367345 | 1 |
CREATED_AT
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 1038198 |
|---|---|
| Distinct (%) | 99.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 79.9 MiB |
| 2022-08-11T19:53:22.794 | 4 |
|---|---|
| 2022-08-12T10:00:17.378 | 4 |
| 2022-08-15T08:43:01.834 | 4 |
| 2022-08-11T10:00:16.488 | 4 |
| 2022-08-10T14:08:09.21 | 4 |
| Other values (1038193) |
Length
| Max length | 23 |
|---|---|
| Median length | 23 |
| Mean length | 22.886986 |
| Min length | 19 |
Characters and Unicode
| Total characters | 23998721 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1028510 ? |
|---|---|
| Unique (%) | 98.1% |
Sample
| 1st row | 2022-07-20T17:17:27.569 |
|---|---|
| 2nd row | 2022-07-20T17:17:27.811 |
| 3rd row | 2022-07-20T17:17:41.301 |
| 4th row | 2022-07-20T17:17:49.666 |
| 5th row | 2022-07-20T17:17:54.482 |
Common Values
| Value | Count | Frequency (%) |
| 2022-08-11T19:53:22.794 | 4 | < 0.1% |
| 2022-08-12T10:00:17.378 | 4 | < 0.1% |
| 2022-08-15T08:43:01.834 | 4 | < 0.1% |
| 2022-08-11T10:00:16.488 | 4 | < 0.1% |
| 2022-08-10T14:08:09.21 | 4 | < 0.1% |
| 2022-08-15T12:17:00.454 | 4 | < 0.1% |
| 2022-08-11T21:33:30.671 | 4 | < 0.1% |
| 2022-08-11T22:50:32.571 | 4 | < 0.1% |
| 2022-08-11T22:41:24.751 | 4 | < 0.1% |
| 2022-08-15T16:10:32.148 | 4 | < 0.1% |
| Other values (1038188) | 1048535 |
Length
| Value | Count | Frequency (%) |
| 2022-08-11t19:53:22.794 | 4 | < 0.1% |
| 2022-08-15t11:32:07.049 | 4 | < 0.1% |
| 2022-08-12t10:00:17.378 | 4 | < 0.1% |
| 2022-08-15t13:55:42.308 | 4 | < 0.1% |
| 2022-08-15t15:11:01.822 | 4 | < 0.1% |
| 2022-08-11t22:59:19.88 | 4 | < 0.1% |
| 2022-08-11t11:52:14.634 | 4 | < 0.1% |
| 2022-08-11t22:38:58.595 | 4 | < 0.1% |
| 2022-08-11t12:39:30.356 | 4 | < 0.1% |
| 2022-08-15t15:38:46.118 | 4 | < 0.1% |
| Other values (1038188) | 1048535 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 5040220 | |
| 0 | 3450246 | |
| 1 | 2251786 | |
| - | 2097150 | |
| : | 2097150 | |
| 3 | 1223650 | 5.1% |
| 4 | 1216237 | 5.1% |
| 5 | 1159734 | 4.8% |
| T | 1048575 | 4.4% |
| . | 1047505 | 4.4% |
| Other values (4) | 3366468 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 17708341 | |
| Other Punctuation | 3144655 | 13.1% |
| Dash Punctuation | 2097150 | 8.7% |
| Uppercase Letter | 1048575 | 4.4% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 5040220 | |
| 0 | 3450246 | |
| 1 | 2251786 | |
| 3 | 1223650 | 6.9% |
| 4 | 1216237 | 6.9% |
| 5 | 1159734 | 6.5% |
| 6 | 910527 | 5.1% |
| 7 | 881095 | 5.0% |
| 8 | 869730 | 4.9% |
| 9 | 705116 | 4.0% |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 2097150 | |
| . | 1047505 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2097150 |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 1048575 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 22950146 | |
| Latin | 1048575 | 4.4% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 5040220 | |
| 0 | 3450246 | |
| 1 | 2251786 | |
| - | 2097150 | |
| : | 2097150 | |
| 3 | 1223650 | 5.3% |
| 4 | 1216237 | 5.3% |
| 5 | 1159734 | 5.1% |
| . | 1047505 | 4.6% |
| 6 | 910527 | 4.0% |
| Other values (3) | 2455941 |
Latin
| Value | Count | Frequency (%) |
| T | 1048575 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 23998721 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 5040220 | |
| 0 | 3450246 | |
| 1 | 2251786 | |
| - | 2097150 | |
| : | 2097150 | |
| 3 | 1223650 | 5.1% |
| 4 | 1216237 | 5.1% |
| 5 | 1159734 | 4.8% |
| T | 1048575 | 4.4% |
| . | 1047505 | 4.4% |
| Other values (4) | 3366468 |
UPDATED_AT
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 1046245 |
|---|---|
| Distinct (%) | 99.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 79.9 MiB |
| 2022-10-12T22:00:00.182 | 4 |
|---|---|
| 2022-08-11T18:30:30.508 | 3 |
| 2022-08-15T13:33:14.997 | 3 |
| 2022-12-24T16:35:57.598 | 3 |
| 2022-08-11T11:52:14.708 | 3 |
| Other values (1046240) |
Length
| Max length | 23 |
|---|---|
| Median length | 23 |
| Mean length | 22.887402 |
| Min length | 19 |
Characters and Unicode
| Total characters | 23999158 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1043925 ? |
|---|---|
| Unique (%) | 99.6% |
Sample
| 1st row | 2022-07-20T17:17:27.62 |
|---|---|
| 2nd row | 2022-07-20T17:17:27.866 |
| 3rd row | 2022-07-20T17:17:41.359 |
| 4th row | 2022-07-20T17:17:49.713 |
| 5th row | 2022-07-20T17:17:54.531 |
Common Values
| Value | Count | Frequency (%) |
| 2022-10-12T22:00:00.182 | 4 | < 0.1% |
| 2022-08-11T18:30:30.508 | 3 | < 0.1% |
| 2022-08-15T13:33:14.997 | 3 | < 0.1% |
| 2022-12-24T16:35:57.598 | 3 | < 0.1% |
| 2022-08-11T11:52:14.708 | 3 | < 0.1% |
| 2022-10-12T23:00:00.112 | 3 | < 0.1% |
| 2022-10-12T18:00:00.112 | 3 | < 0.1% |
| 2022-05-23T22:20:06.174 | 3 | < 0.1% |
| 2022-08-26T18:00:00.05 | 3 | < 0.1% |
| 2022-08-22T19:38:03.881 | 2 | < 0.1% |
| Other values (1046235) | 1048545 |
Length
| Value | Count | Frequency (%) |
| 2022-10-12t22:00:00.182 | 4 | < 0.1% |
| 2022-10-12t23:00:00.112 | 3 | < 0.1% |
| 2022-08-11t18:30:30.508 | 3 | < 0.1% |
| 2022-05-23t22:20:06.174 | 3 | < 0.1% |
| 2022-10-12t18:00:00.112 | 3 | < 0.1% |
| 2022-08-26t18:00:00.05 | 3 | < 0.1% |
| 2022-08-11t11:52:14.708 | 3 | < 0.1% |
| 2022-12-24t16:35:57.598 | 3 | < 0.1% |
| 2022-08-15t13:33:14.997 | 3 | < 0.1% |
| 2022-08-15t13:14:25.938 | 2 | < 0.1% |
| Other values (1046235) | 1048545 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 5039537 | |
| 0 | 3454083 | |
| 1 | 2248470 | |
| - | 2097150 | |
| : | 2097150 | |
| 3 | 1222121 | 5.1% |
| 4 | 1216125 | 5.1% |
| 5 | 1160727 | 4.8% |
| T | 1048575 | 4.4% |
| . | 1047502 | 4.4% |
| Other values (4) | 3367718 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 17708781 | |
| Other Punctuation | 3144652 | 13.1% |
| Dash Punctuation | 2097150 | 8.7% |
| Uppercase Letter | 1048575 | 4.4% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 5039537 | |
| 0 | 3454083 | |
| 1 | 2248470 | |
| 3 | 1222121 | 6.9% |
| 4 | 1216125 | 6.9% |
| 5 | 1160727 | 6.6% |
| 6 | 913817 | 5.2% |
| 7 | 879531 | 5.0% |
| 8 | 872658 | 4.9% |
| 9 | 701712 | 4.0% |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 2097150 | |
| . | 1047502 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2097150 |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 1048575 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 22950583 | |
| Latin | 1048575 | 4.4% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 5039537 | |
| 0 | 3454083 | |
| 1 | 2248470 | |
| - | 2097150 | |
| : | 2097150 | |
| 3 | 1222121 | 5.3% |
| 4 | 1216125 | 5.3% |
| 5 | 1160727 | 5.1% |
| . | 1047502 | 4.6% |
| 6 | 913817 | 4.0% |
| Other values (3) | 2453901 |
Latin
| Value | Count | Frequency (%) |
| T | 1048575 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 23999158 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 5039537 | |
| 0 | 3454083 | |
| 1 | 2248470 | |
| - | 2097150 | |
| : | 2097150 | |
| 3 | 1222121 | 5.1% |
| 4 | 1216125 | 5.1% |
| 5 | 1160727 | 4.8% |
| T | 1048575 | 4.4% |
| . | 1047502 | 4.4% |
| Other values (4) | 3367718 |
AMOUNT
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 5646 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.469001 |
| Minimum | 1 |
|---|---|
| Maximum | 20000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 7 |
| median | 10 |
| Q3 | 10 |
| 95-th percentile | 75.25 |
| Maximum | 20000 |
| Range | 19999 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 184.76429 |
|---|---|
| Coefficient of variation (CV) | 6.7262834 |
| Kurtosis | 1873.6826 |
| Mean | 27.469001 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 32.925593 |
| Sum | 28803308 |
| Variance | 34137.841 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 361689 | |
| 9 | 253659 | |
| 7 | 138598 | 13.2% |
| 5 | 71209 | 6.8% |
| 4.25 | 25612 | 2.4% |
| 15 | 24875 | 2.4% |
| 2.5 | 22448 | 2.1% |
| 50 | 11223 | 1.1% |
| 13.5 | 10431 | 1.0% |
| 100 | 9497 | 0.9% |
| Other values (5636) | 119334 | 11.4% |
| Value | Count | Frequency (%) |
| 1 | 6 | < 0.1% |
| 1.15 | 1 | < 0.1% |
| 1.34 | 1 | < 0.1% |
| 1.43 | 1 | < 0.1% |
| 1.75 | 1 | < 0.1% |
| 2 | 3 | < 0.1% |
| 2.25 | 1 | < 0.1% |
| 2.46 | 3 | < 0.1% |
| 2.5 | 22448 | |
| 2.6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 20000 | 2 | |
| 19905 | 1 | |
| 19575.56 | 1 | |
| 18000 | 1 | |
| 17000 | 1 | |
| 16871.54 | 1 | |
| 16295.88 | 1 | |
| 16267.51 | 1 | |
| 15886 | 1 | |
| 15306.02 | 1 |
FEES
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 550 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.49690479 |
| Minimum | 0 |
|---|---|
| Maximum | 450.01 |
| Zeros | 5990 |
| Zeros (%) | 0.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.12 |
| Q1 | 0.21 |
| median | 0.23 |
| Q3 | 0.25 |
| 95-th percentile | 2.3 |
| Maximum | 450.01 |
| Range | 450.01 |
| Interquartile range (IQR) | 0.04 |
Descriptive statistics
| Standard deviation | 1.2591194 |
|---|---|
| Coefficient of variation (CV) | 2.5339249 |
| Kurtosis | 20947.592 |
| Mean | 0.49690479 |
| Median Absolute Deviation (MAD) | 0.02 |
| Skewness | 82.217872 |
| Sum | 521041.94 |
| Variance | 1.5853818 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.23 | 345859 | |
| 0.21 | 211091 | |
| 0.25 | 95527 | 9.1% |
| 0.12 | 62533 | 6.0% |
| 0.17 | 35374 | 3.4% |
| 0.35 | 19619 | 1.9% |
| 0.06 | 18152 | 1.7% |
| 0.2 | 17646 | 1.7% |
| 2.28 | 17322 | 1.7% |
| 0.18 | 16100 | 1.5% |
| Other values (540) | 209352 |
| Value | Count | Frequency (%) |
| 0 | 5990 | 0.6% |
| 0.02 | 23 | < 0.1% |
| 0.03 | 3 | < 0.1% |
| 0.04 | 10 | < 0.1% |
| 0.05 | 8 | < 0.1% |
| 0.06 | 18152 | |
| 0.07 | 4315 | 0.4% |
| 0.08 | 14 | < 0.1% |
| 0.09 | 12 | < 0.1% |
| 0.1 | 11636 |
| Value | Count | Frequency (%) |
| 450.01 | 1 | < 0.1% |
| 220.33 | 1 | < 0.1% |
| 195.31 | 6 | |
| 193.45 | 1 | < 0.1% |
| 177.73 | 1 | < 0.1% |
| 160.3 | 1 | < 0.1% |
| 97.66 | 3 | |
| 56.26 | 2 | < 0.1% |
| 48.79 | 3 | |
| 44.11 | 1 | < 0.1% |
RETAILER_CUT
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 396 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.23433452 |
| Minimum | 0 |
|---|---|
| Maximum | 125.1 |
| Zeros | 6582 |
| Zeros (%) | 0.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.06 |
| Q1 | 0.11 |
| median | 0.13 |
| Q3 | 0.15 |
| 95-th percentile | 0.93 |
| Maximum | 125.1 |
| Range | 125.1 |
| Interquartile range (IQR) | 0.04 |
Descriptive statistics
| Standard deviation | 0.44448852 |
|---|---|
| Coefficient of variation (CV) | 1.8968119 |
| Kurtosis | 8025.9584 |
| Mean | 0.23433452 |
| Median Absolute Deviation (MAD) | 0.02 |
| Skewness | 41.577119 |
| Sum | 245717.32 |
| Variance | 0.19757004 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.13 | 369698 | |
| 0.11 | 185180 | |
| 0.15 | 125153 | 11.9% |
| 0.06 | 65147 | 6.2% |
| 0.09 | 34863 | 3.3% |
| 0.07 | 25003 | 2.4% |
| 0.19 | 18721 | 1.8% |
| 0.03 | 18193 | 1.7% |
| 0.61 | 17577 | 1.7% |
| 2 | 17150 | 1.6% |
| Other values (386) | 171890 |
| Value | Count | Frequency (%) |
| 0 | 6582 | 0.6% |
| 0.03 | 18193 | 1.7% |
| 0.04 | 4257 | 0.4% |
| 0.05 | 2708 | 0.3% |
| 0.06 | 65147 | 6.2% |
| 0.07 | 25003 | 2.4% |
| 0.08 | 637 | 0.1% |
| 0.09 | 34863 | 3.3% |
| 0.1 | 16318 | 1.6% |
| 0.11 | 185180 |
| Value | Count | Frequency (%) |
| 125.1 | 1 | < 0.1% |
| 61.25 | 1 | < 0.1% |
| 54.29 | 6 | |
| 53.77 | 1 | < 0.1% |
| 49.4 | 1 | < 0.1% |
| 44.56 | 1 | < 0.1% |
| 27.14 | 3 | |
| 15.64 | 2 | < 0.1% |
| 13.56 | 3 | |
| 12.26 | 1 | < 0.1% |
STATUS
Categorical
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 67.1 MiB |
| SUCCESSFUL | |
|---|---|
| PROVIDER_FAILED | 8125 |
| BALANCE_FAILED | 6695 |
| CANCELED | 670 |
| NOT_PROCESSED_FAILED | 116 |
| Other values (3) | 12 |
Length
| Max length | 20 |
|---|---|
| Median length | 10 |
| Mean length | 10.064159 |
| Min length | 8 |
Characters and Unicode
| Total characters | 10553026 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | SUCCESSFUL |
|---|---|
| 2nd row | SUCCESSFUL |
| 3rd row | SUCCESSFUL |
| 4th row | SUCCESSFUL |
| 5th row | SUCCESSFUL |
Common Values
| Value | Count | Frequency (%) |
| SUCCESSFUL | 1032957 | |
| PROVIDER_FAILED | 8125 | 0.8% |
| BALANCE_FAILED | 6695 | 0.6% |
| CANCELED | 670 | 0.1% |
| NOT_PROCESSED_FAILED | 116 | < 0.1% |
| CLIENT_PENDING | 7 | < 0.1% |
| CONFIRM_PENDING | 4 | < 0.1% |
| CANCEL_FAILED | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| successful | 1032957 | |
| provider_failed | 8125 | 0.8% |
| balance_failed | 6695 | 0.6% |
| canceled | 670 | 0.1% |
| not_processed_failed | 116 | < 0.1% |
| client_pending | 7 | < 0.1% |
| confirm_pending | 4 | < 0.1% |
| cancel_failed | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 3099103 | |
| C | 2074078 | |
| U | 2065914 | |
| E | 1064305 | 10.1% |
| L | 1055267 | 10.0% |
| F | 1047898 | 9.9% |
| A | 28998 | 0.3% |
| D | 23859 | 0.2% |
| I | 23084 | 0.2% |
| R | 16370 | 0.2% |
| Other values (9) | 54150 | 0.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 10537962 | |
| Connector Punctuation | 15064 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 3099103 | |
| C | 2074078 | |
| U | 2065914 | |
| E | 1064305 | 10.1% |
| L | 1055267 | 10.0% |
| F | 1047898 | 9.9% |
| A | 28998 | 0.3% |
| D | 23859 | 0.2% |
| I | 23084 | 0.2% |
| R | 16370 | 0.2% |
| Other values (8) | 39086 | 0.4% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 15064 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 10537962 | |
| Common | 15064 | 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 3099103 | |
| C | 2074078 | |
| U | 2065914 | |
| E | 1064305 | 10.1% |
| L | 1055267 | 10.0% |
| F | 1047898 | 9.9% |
| A | 28998 | 0.3% |
| D | 23859 | 0.2% |
| I | 23084 | 0.2% |
| R | 16370 | 0.2% |
| Other values (8) | 39086 | 0.4% |
Common
| Value | Count | Frequency (%) |
| _ | 15064 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10553026 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 3099103 | |
| C | 2074078 | |
| U | 2065914 | |
| E | 1064305 | 10.1% |
| L | 1055267 | 10.0% |
| F | 1047898 | 9.9% |
| A | 28998 | 0.3% |
| D | 23859 | 0.2% |
| I | 23084 | 0.2% |
| R | 16370 | 0.2% |
| Other values (9) | 54150 | 0.5% |
TOTAL_AMOUNT_INCLUDING_TAX
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 5732 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.68107 |
| Minimum | 1 |
|---|---|
| Maximum | 20000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 9 |
| median | 10 |
| Q3 | 10 |
| 95-th percentile | 95.72 |
| Maximum | 20000 |
| Range | 19999 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 185.00397 |
|---|---|
| Coefficient of variation (CV) | 6.4503857 |
| Kurtosis | 1863.1206 |
| Mean | 28.68107 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 32.780872 |
| Sum | 30074253 |
| Variance | 34226.468 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 417944 | |
| 9 | 257269 | |
| 5 | 68177 | 6.5% |
| 7 | 52029 | 5.0% |
| 15 | 28029 | 2.7% |
| 10.01 | 26839 | 2.6% |
| 4.25 | 25612 | 2.4% |
| 2.5 | 22448 | 2.1% |
| 50 | 11482 | 1.1% |
| 13.5 | 10430 | 1.0% |
| Other values (5722) | 128316 | 12.2% |
| Value | Count | Frequency (%) |
| 1 | 6 | < 0.1% |
| 1.15 | 1 | < 0.1% |
| 1.34 | 1 | < 0.1% |
| 1.43 | 1 | < 0.1% |
| 1.75 | 1 | < 0.1% |
| 2 | 3 | < 0.1% |
| 2.25 | 1 | < 0.1% |
| 2.46 | 3 | < 0.1% |
| 2.5 | 22448 | |
| 2.6 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 20000 | 2 | |
| 19905 | 1 | |
| 19575.56 | 1 | |
| 18000 | 1 | |
| 17000 | 1 | |
| 16871.54 | 1 | |
| 16295.88 | 1 | |
| 16267.51 | 1 | |
| 15886 | 1 | |
| 15306.02 | 1 |
TOTAL_AMOUNT_PAID
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 6826 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.899008 |
| Minimum | 1 |
|---|---|
| Maximum | 20000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 9 |
| median | 10 |
| Q3 | 10 |
| 95-th percentile | 98.42 |
| Maximum | 20000 |
| Range | 19999 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 185.23041 |
|---|---|
| Coefficient of variation (CV) | 6.4095766 |
| Kurtosis | 1854.3742 |
| Mean | 28.899008 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 32.680721 |
| Sum | 30302778 |
| Variance | 34310.305 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 417862 | |
| 9 | 257044 | |
| 5 | 68157 | 6.5% |
| 7 | 52025 | 5.0% |
| 15 | 27620 | 2.6% |
| 10.01 | 26838 | 2.6% |
| 4.25 | 25611 | 2.4% |
| 2.5 | 22448 | 2.1% |
| 13.5 | 10435 | 1.0% |
| 25 | 8393 | 0.8% |
| Other values (6816) | 132142 | 12.6% |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 1.15 | 1 | < 0.1% |
| 1.34 | 1 | < 0.1% |
| 1.43 | 1 | < 0.1% |
| 2 | 3 | < 0.1% |
| 2.25 | 1 | < 0.1% |
| 2.46 | 3 | < 0.1% |
| 2.5 | 22448 | |
| 3 | 3 | < 0.1% |
| 3.3 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 20000 | 2 | |
| 19905 | 1 | |
| 19575.56 | 1 | |
| 18000 | 1 | |
| 17000 | 1 | |
| 16871.54 | 1 | |
| 16295.88 | 1 | |
| 16267.51 | 1 | |
| 15886 | 1 | |
| 15306.02 | 1 |
WALLET_BALANCE_BEFORE_TRANSACTION
Real number (ℝ)
| Distinct | 275562 |
|---|---|
| Distinct (%) | 26.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1007.0043 |
| Minimum | -14324.51 |
|---|---|
| Maximum | 32983.59 |
| Zeros | 38 |
| Zeros (%) | < 0.1% |
| Negative | 188 |
| Negative (%) | < 0.1% |
| Memory size | 8.0 MiB |
Quantile statistics
| Minimum | -14324.51 |
|---|---|
| 5-th percentile | 84.37 |
| Q1 | 409.51 |
| median | 806.94 |
| Q3 | 1306.73 |
| 95-th percentile | 2625.903 |
| Maximum | 32983.59 |
| Range | 47308.1 |
| Interquartile range (IQR) | 897.22 |
Descriptive statistics
| Standard deviation | 1009.167 |
|---|---|
| Coefficient of variation (CV) | 1.0021477 |
| Kurtosis | 90.879145 |
| Mean | 1007.0043 |
| Median Absolute Deviation (MAD) | 435.64 |
| Skewness | 5.7899016 |
| Sum | 1.0559195 × 109 |
| Variance | 1018418 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 375.28 | 58 | < 0.1% |
| 500 | 55 | < 0.1% |
| 1000 | 52 | < 0.1% |
| 0 | 38 | < 0.1% |
| 308.41 | 33 | < 0.1% |
| 773.13 | 28 | < 0.1% |
| 300 | 21 | < 0.1% |
| 340.14 | 20 | < 0.1% |
| 14.11 | 20 | < 0.1% |
| 66.34 | 20 | < 0.1% |
| Other values (275552) | 1048230 |
| Value | Count | Frequency (%) |
| -14324.51 | 1 | < 0.1% |
| -9017.29 | 2 | |
| -7017.57 | 3 | |
| -2998.42 | 1 | < 0.1% |
| -2996.53 | 2 | |
| -2995.24 | 1 | < 0.1% |
| -2988.42 | 2 | |
| -2971.22 | 2 | |
| -2842.06 | 1 | < 0.1% |
| -2579.18 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 32983.59 | 1 | |
| 32961.92 | 1 | |
| 32718.51 | 1 | |
| 32713.33 | 1 | |
| 32706.43 | 1 | |
| 32697.56 | 1 | |
| 32688.69 | 1 | |
| 32684.5 | 1 | |
| 32657.83 | 1 | |
| 32648.96 | 1 |
MAIN_SYSTEM_ID
Real number (ℝ)
| Distinct | 4944 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 50529.554 |
| Minimum | 102 |
|---|---|
| Maximum | 156199 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 MiB |
Quantile statistics
| Minimum | 102 |
|---|---|
| 5-th percentile | 7102 |
| Q1 | 19158 |
| median | 40311 |
| Q3 | 73267 |
| 95-th percentile | 122403 |
| Maximum | 156199 |
| Range | 156097 |
| Interquartile range (IQR) | 54109 |
Descriptive statistics
| Standard deviation | 37722.2 |
|---|---|
| Coefficient of variation (CV) | 0.74653737 |
| Kurtosis | -0.026037972 |
| Mean | 50529.554 |
| Median Absolute Deviation (MAD) | 24415 |
| Skewness | 0.88151721 |
| Sum | 5.2984027 × 1010 |
| Variance | 1.4229644 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 39409 | 2264 | 0.2% |
| 14163 | 2129 | 0.2% |
| 15200 | 1747 | 0.2% |
| 49687 | 1711 | 0.2% |
| 30067 | 1706 | 0.2% |
| 18091 | 1665 | 0.2% |
| 40758 | 1624 | 0.2% |
| 17611 | 1601 | 0.2% |
| 54819 | 1573 | 0.2% |
| 36543 | 1572 | 0.1% |
| Other values (4934) | 1030983 |
| Value | Count | Frequency (%) |
| 102 | 209 | |
| 115 | 174 | |
| 122 | 1 | < 0.1% |
| 193 | 165 | |
| 247 | 117 | < 0.1% |
| 248 | 74 | < 0.1% |
| 275 | 64 | < 0.1% |
| 290 | 301 | |
| 296 | 215 | |
| 300 | 299 |
| Value | Count | Frequency (%) |
| 156199 | 81 | < 0.1% |
| 156063 | 35 | < 0.1% |
| 155983 | 4 | < 0.1% |
| 155952 | 33 | < 0.1% |
| 155936 | 3 | < 0.1% |
| 155917 | 399 | |
| 155894 | 320 | |
| 155803 | 131 | < 0.1% |
| 155673 | 50 | < 0.1% |
| 155667 | 131 | < 0.1% |
| ID | AMOUNT | FEES | RETAILER_CUT | TOTAL_AMOUNT_INCLUDING_TAX | TOTAL_AMOUNT_PAID | WALLET_BALANCE_BEFORE_TRANSACTION | MAIN_SYSTEM_ID | STATUS | |
|---|---|---|---|---|---|---|---|---|---|
| ID | 1.000 | 0.093 | -0.087 | -0.161 | 0.094 | 0.094 | 0.029 | 0.030 | 0.018 |
| AMOUNT | 0.093 | 1.000 | 0.833 | 0.782 | 0.845 | 0.844 | 0.047 | -0.007 | 0.012 |
| FEES | -0.087 | 0.833 | 1.000 | 0.948 | 0.854 | 0.855 | 0.022 | -0.010 | 0.018 |
| RETAILER_CUT | -0.161 | 0.782 | 0.948 | 1.000 | 0.873 | 0.874 | 0.021 | -0.003 | 0.018 |
| TOTAL_AMOUNT_INCLUDING_TAX | 0.094 | 0.845 | 0.854 | 0.873 | 1.000 | 0.999 | 0.048 | 0.008 | 0.012 |
| TOTAL_AMOUNT_PAID | 0.094 | 0.844 | 0.855 | 0.874 | 0.999 | 1.000 | 0.048 | 0.008 | 0.013 |
| WALLET_BALANCE_BEFORE_TRANSACTION | 0.029 | 0.047 | 0.022 | 0.021 | 0.048 | 0.048 | 1.000 | -0.022 | 0.059 |
| MAIN_SYSTEM_ID | 0.030 | -0.007 | -0.010 | -0.003 | 0.008 | 0.008 | -0.022 | 1.000 | 0.008 |
| STATUS | 0.018 | 0.012 | 0.018 | 0.018 | 0.012 | 0.013 | 0.059 | 0.008 | 1.000 |
| ID | CREATED_AT | UPDATED_AT | AMOUNT | FEES | RETAILER_CUT | STATUS | TOTAL_AMOUNT_INCLUDING_TAX | TOTAL_AMOUNT_PAID | WALLET_BALANCE_BEFORE_TRANSACTION | MAIN_SYSTEM_ID | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 21321668 | 2022-07-20T17:17:27.569 | 2022-07-20T17:17:27.62 | 7.0 | 0.23 | 0.13 | SUCCESSFUL | 10.0 | 10.0 | 1017.11 | 78550 |
| 1 | 21321669 | 2022-07-20T17:17:27.811 | 2022-07-20T17:17:27.866 | 10.0 | 0.23 | 0.13 | SUCCESSFUL | 10.0 | 10.0 | 1079.96 | 116836 |
| 2 | 21321697 | 2022-07-20T17:17:41.301 | 2022-07-20T17:17:41.359 | 9.0 | 0.21 | 0.11 | SUCCESSFUL | 9.0 | 9.0 | 167.51 | 28799 |
| 3 | 21321718 | 2022-07-20T17:17:49.666 | 2022-07-20T17:17:49.713 | 9.0 | 0.21 | 0.11 | SUCCESSFUL | 9.0 | 9.0 | 481.48 | 87876 |
| 4 | 21321728 | 2022-07-20T17:17:54.482 | 2022-07-20T17:17:54.531 | 9.0 | 0.21 | 0.11 | SUCCESSFUL | 9.0 | 9.0 | 639.58 | 18899 |
| 5 | 24734499 | 2022-08-11T09:52:00.352 | 2022-08-11T09:52:00.402 | 10.0 | 0.23 | 0.13 | SUCCESSFUL | 10.0 | 10.0 | 2841.20 | 8364 |
| 6 | 24743629 | 2022-08-11T11:11:00.339 | 2022-08-11T11:11:00.394 | 10.0 | 0.23 | 0.13 | SUCCESSFUL | 10.0 | 10.0 | 395.37 | 93466 |
| 7 | 24743640 | 2022-08-11T11:11:07.369 | 2022-08-11T11:11:07.369 | 85.5 | 5.00 | 2.00 | SUCCESSFUL | 85.5 | 90.5 | 341.08 | 61066 |
| 8 | 31158548 | 2022-09-17T05:51:21.359 | 2022-09-17T05:51:21.408 | 10.0 | 0.23 | 0.12 | SUCCESSFUL | 10.0 | 10.0 | 297.55 | 14496 |
| 9 | 18064286 | 2022-06-27T12:50:09.719 | 2022-06-27T12:50:09.8 | 7.0 | 0.23 | 0.13 | SUCCESSFUL | 10.0 | 10.0 | 1443.08 | 14940 |
| ID | CREATED_AT | UPDATED_AT | AMOUNT | FEES | RETAILER_CUT | STATUS | TOTAL_AMOUNT_INCLUDING_TAX | TOTAL_AMOUNT_PAID | WALLET_BALANCE_BEFORE_TRANSACTION | MAIN_SYSTEM_ID | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1048565 | 8712138 | 2022-04-10T17:57:12.839 | 2022-04-10T17:57:12.88 | 10.00 | 0.25 | 0.15 | SUCCESSFUL | 10.00 | 10.00 | 795.32 | 5027 |
| 1048566 | 8712745 | 2022-04-10T18:03:18.445 | 2022-04-10T18:03:18.495 | 10.00 | 0.25 | 0.15 | SUCCESSFUL | 10.00 | 10.00 | 1988.81 | 40973 |
| 1048567 | 8712755 | 2022-04-10T18:03:25.481 | 2022-04-10T18:03:25.535 | 10.00 | 0.25 | 0.15 | SUCCESSFUL | 10.00 | 10.00 | 2715.30 | 25741 |
| 1048568 | 8712764 | 2022-04-10T18:03:35.043 | 2022-04-10T18:03:35.095 | 10.00 | 0.25 | 0.15 | SUCCESSFUL | 10.00 | 10.00 | 291.52 | 39481 |
| 1048569 | 10369017 | 2022-04-25T23:32:41.414 | 2022-04-25T23:32:41.46 | 15.00 | 0.38 | 0.22 | SUCCESSFUL | 15.00 | 15.00 | 1449.10 | 50801 |
| 1048570 | 10369024 | 2022-04-25T23:32:42.53 | 2022-04-25T23:32:42.593 | 10.00 | 0.25 | 0.15 | SUCCESSFUL | 10.00 | 10.00 | 481.24 | 39409 |
| 1048571 | 8711282 | 2022-04-10T17:48:54.039 | 2022-04-10T17:48:54.126 | 10.00 | 0.25 | 0.15 | SUCCESSFUL | 10.00 | 10.00 | 216.52 | 26615 |
| 1048572 | 8711283 | 2022-04-10T17:48:54.732 | 2022-04-10T17:48:54.81 | 7.00 | 0.18 | 0.10 | SUCCESSFUL | 7.00 | 7.00 | 1515.91 | 50900 |
| 1048573 | 8711284 | 2022-04-10T17:48:55.113 | 2022-04-10T17:48:55.185 | 10.00 | 0.25 | 0.15 | SUCCESSFUL | 10.00 | 10.00 | 570.69 | 31528 |
| 1048574 | 8711285 | 2022-04-10T17:48:55.924 | 2022-04-10T17:48:55.995 | 4.25 | 0.11 | 0.06 | SUCCESSFUL | 4.25 | 4.25 | 1140.52 | 29277 |